set arithabort on

CREATE PRIMARY XML INDEX PXML_PRODUCTMODEL_CATALOGDESCRIPTION
ON Production.ProductModel(CatalogDescription)

--Select CatalogDescrition.query('/ItemList/Item[@ProductID="1"]')
CREATE XML INDEX XMLPATH_PRODUCTMODEL_CATALOGDESCRIPTION
ON Production.ProductModel(CatalogDescription)
USING XML INDEX PXML_PRODUCTMODEL_CATALOGDESCRIPTION
FOR PATH

--Select CatalogDescrition.value(('/ItemList/Item/@ProductID)[1]')
CREATE XML INDEX XMLPROPERTY_PRODUCTMODEL_CATALOGDESCRIPTION
ON Production.ProductModel(CatalogDescription)
USING XML INDEX PXML_PRODUCTMODEL_CATALOGDESCRIPTION
FOR PROPERTY

--Select CatalogDescrition.query('//Item[@ProductID="1"]')
CREATE XML INDEX XMLVALUE_PRODUCTMODEL_CATALOGDESCRIPTION
ON Production.ProductModel(CatalogDescription)
USING XML INDEX PXML_PRODUCTMODEL_CATALOGDESCRIPTION
FOR VALUE




